Microsoft Excel 2019/2016. Анализ и визуализация данных
0 0
Забронировать курс
Спасибо за интерес к нашему курсу! Обратитесь через форму «Запросить информацию» для получения более точной информации о датах обучения.
-
Аннотация
-
Описание образовательной программы
В рамках данного курса будут рассмотрены вопросы как быстро и эффективно создавать сложные, но наглядные интерактивные диаграммы для визуализации ваших отчетов и данных.
Пройдя обучение на этом курсе, Вы повысите свой «словарный запас» встроенных функций MS Excel в рамках категории «Ссылки и массивы», а в совокупности с формулами массивов перед Вами откроются новые возможности обработки данных. Вы научитесь создавать нестандартные сложные диаграммы, которые помогут визуализировать данные, сделать их запоминающимися и легкими в управлении. Вы узнаете о новых типах диаграмм, которые появились только в Microsoft Excel 2019/2016
Целевая аудитория
Специалисты различного профиля, владеющие уверенными знаниями Microsoft Excel уровня 1 и желающие расширить свои знания для выполнения наиболее распространенных задач в программе Microsoft Excel 2019/2016
Содержание
Применение категории встроенных функций «Ссылки и Массивы» и формул массивов
- Формулы массивов
- Использование в простых расчетах
- Применение функций в формулах массивов
- Решение задач по извлечению данных из массива данных:
- Двусторонний поиск
- Поиск по нескольким критериям
- Двусторонний многокритериальный поиск
- С применением функций СТРОКА, СТОЛБЕЦ
- Использование именованных диапазонов в расчетах
- Применение функции ДВССЫЛ в решении задач:
- Обработка данных с одного или нескольких листов
- Создание зависимых списков с постоянным источником
- Работа с функцией СМЕЩ
Пользовательские форматы
- Создание пользовательских форматов:
- Числовые форматы
- Форматы даты и времени
- Группы пользовательских форматов
- Редактирование, применение и удаление форматов
Диаграммы
- Спарклайны
- Комбинированные диаграммы
- Гистограмма с отображением итогов
- Проектная диаграмма Ганта
- Диаграмма сравнений Торнадо
- Каскадная диаграмма (диаграмма отклонений Водопад)
- Иерархические диаграммы:
- Солнечные лучи
- Иерархическая
- Статистические диаграммы:
- Диаграмма Парето
- Ящик с усами
- Частотная диаграмма
- Создание калибровочной диаграммы Термометр
- Диаграммы с пользовательскими элементами управления:
- Диаграмма с включением/выключением рядов данных
- Диаграмма с выбором значений и отображением средних, минимальных и максимальных значений
Прогнозирование данных
- Выделение тренда:
- Скользящее среднее
- Функции регрессионного анализа: ПРЕДСКАЗ, ТЕНДЕНЦИЯ, РОСТ
- Построение линий тренда
- Учет сезонности в прогнозах
- Быстрый прогноз с использованием листа прогноза
Вариативный анализ «Что Если» и Оптимизация
- Использование инструмента Таблица данных для анализа развития ситуации при 2-х переменных
- Оценка развития ситуации и выбор оптимальной стратегии с помощью Сценариев
- Решение однокритериальной задачи оптимизации с помощью Подбора параметра
- Решение многокритериальных задач оптимизации с использованием надстройки Поиск решения
Обработка внешних баз данных
- Импорт внешних данных: Web, Access, Text
- Запросы (Microsoft Query) к внешним базам данных : Access, Excel
- Кубы данных OLAP для оперативного анализа данных в MS Excel
- Введение в кубы данных: что такое кубы OLAP и их назначение
- Преимущества использования кубов данных OLAP
- Особенности работы со сводной таблицей OLAP
-
Получаемый документ
-
Необходимая подготовка
Желательно прохождение курса Microsoft Excel 2019/2016. Расширенные возможности
-
Цель курса
Фомирование знаний и практических навыков по анализу и визуализации данных в Microsoft Excel 2019/2016.
Преподаватели
Рекомендуемые курсы
- Понимать структуру книги Excel
- Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий
- Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах
- Получать результаты расчета данных по функциям
- Оформлять таблицы в соответствии с любыми требованиями
- Строить диаграммы для наглядного представления табличных данных
- Осуществлять сортировку и фильтровку данных
- Подготовить и вывести на печать как таблицу, так и диаграмму
- Понимать структуру книги Excel
- Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий
- Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах
- Получать результаты расчета данных по функциям
- Оформлять таблицы в соответствии с любыми требованиями
- Строить диаграммы для наглядного представления табличных данных
- Осуществлять сортировку и фильтровку данных
- Подготовить и вывести на печать как таблицу, так и диаграмму
Формирование знаний и практических навыков по использованию Microsoft Excel 2019/2016. Базовый уровень
[TYPE] => HTML ) [~DESCRIPTION] => ) [AUDIT_CATALOG] => Array ( [ID] => 75 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория [ACTIVE] => Y [SORT] => 750 [CODE] => AUDIT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 75 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Целевая аудитория [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TRAIN_CATALOG] => Array ( [ID] => 76 [IBLOCK_ID] => 26 [NAME] => Необходимая подготовка [ACTIVE] => Y [SORT] => 800 [CODE] => TRAIN_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 76 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Необходимая подготовка [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [CONTENT_CATALOG] => Array ( [ID] => 77 [IBLOCK_ID] => 26 [NAME] => Содержание [ACTIVE] => Y [SORT] => 850 [CODE] => CONTENT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 77 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Содержание [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_CATALOG] => Array ( [ID] => 78 [IBLOCK_ID] => 26 [NAME] => Сертификация [ACTIVE] => Y [SORT] => 900 [CODE] => SERTIF_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 78 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Сертификация [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DOC_CATALOG] => Array ( [ID] => 79 [IBLOCK_ID] => 26 [NAME] => Получаемый документ [ACTIVE] => Y [SORT] => 950 [CODE] => DOC_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 79 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Получаемый документ [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <img width="437" alt="Сертификат.jpg" src="/upload/medialibrary/b37/b370784d3f620d37311f6ecb970a4aec.jpg" height="300" title="Сертификат.jpg"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896291 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [~DESCRIPTION] => ) [LENGTH_CATALOG] => Array ( [ID] => 80 [IBLOCK_ID] => 26 [NAME] => Продолжительность обучения [ACTIVE] => Y [SORT] => 1000 [CODE] => LENGTH_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 80 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Продолжительность обучения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 2 дня /16 часов [PROPERTY_VALUE_ID] => 20893801 [DESCRIPTION] => [~VALUE] => 2 дня /16 часов [~DESCRIPTION] => ) [prepodavatel] => Array ( [ID] => 82 [IBLOCK_ID] => 26 [NAME] => Преподаватели [ACTIVE] => Y [SORT] => 1050 [CODE] => prepodavatel [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 82 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Преподаватели [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 163 [1] => 10420 [2] => 2852 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901269 [1] => 20901270 [2] => 20901271 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => ) [~VALUE] => Array ( [0] => 163 [1] => 10420 [2] => 2852 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => ) ) [FORUM_TOPIC_ID] => Array ( [ID] => 175 [IBLOCK_ID] => 26 [NAME] => Тема форума для комментариев [ACTIVE] => Y [SORT] => 1150 [CODE] => FORUM_TOPIC_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 175 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тема форума для комментариев [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [FORUM_MESSAGE_CNT] => Array ( [ID] => 176 [IBLOCK_ID] => 26 [NAME] => Количество комментариев к элементу [ACTIVE] => Y [SORT] => 1200 [CODE] => FORUM_MESSAGE_CNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 176 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество комментариев к элементу [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [OPTIONS_CATALOG] => Array ( [ID] => 229 [IBLOCK_ID] => 26 [NAME] => Доп. опции [ACTIVE] => Y [SORT] => 1300 [CODE] => OPTIONS_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 229 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 60 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => EList [USER_TYPE_SETTINGS] => Array ( [size] => 1 [width] => 0 [group] => N [multiple] => N ) [HINT] => [~NAME] => Доп. опции [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [MOODLE_ID] => Array ( [ID] => 244 [IBLOCK_ID] => 26 [NAME] => ID курса в СДО [ACTIVE] => Y [SORT] => 1350 [CODE] => MOODLE_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => ID курса в СДО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [COUNT_ORDER] => Array ( [ID] => 248 [IBLOCK_ID] => 26 [NAME] => Количество заказов [ACTIVE] => Y [SORT] => 1400 [CODE] => COUNT_ORDER [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество заказов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [IN_ASO] => Array ( [ID] => 251 [IBLOCK_ID] => 26 [NAME] => Курс в АСО [ACTIVE] => Y [SORT] => 1450 [CODE] => IN_ASO [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс в АСО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [VARIANTY_VIEZD] => Array ( [ID] => 384 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория (Новый блок) [ACTIVE] => Y [SORT] => 1500 [CODE] => VARIANTY_VIEZD [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 288 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Целевая аудитория (Новый блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 25357 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364288 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 25357 ) [~DESCRIPTION] => Array ( [0] => ) ) [RAZPISANIE] => Array ( [ID] => 385 [IBLOCK_ID] => 26 [NAME] => Расписание [ACTIVE] => Y [SORT] => 1550 [CODE] => RAZPISANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 289 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 64 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 26238 [1] => 26239 [2] => 26240 [3] => 26241 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364289 [1] => 21364290 [2] => 21364291 [3] => 21364292 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) [~VALUE] => Array ( [0] => 26238 [1] => 26239 [2] => 26240 [3] => 26241 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) ) [VIDEO] => Array ( [ID] => 386 [IBLOCK_ID] => 26 [NAME] => Видео [ACTIVE] => Y [SORT] => 1600 [CODE] => VIDEO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 293 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Видео [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [EKSAMEN] => Array ( [ID] => 387 [IBLOCK_ID] => 26 [NAME] => Экзамены [ACTIVE] => Y [SORT] => 1650 [CODE] => EKSAMEN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 294 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Экзамены [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [prods] => Array ( [ID] => 83 [IBLOCK_ID] => 26 [NAME] => Похожие (связанные) продукты [ACTIVE] => Y [SORT] => 1670 [CODE] => prods [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 83 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Похожие (связанные) продукты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 12260 [1] => 12257 [2] => 12256 [3] => 12259 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901272 [1] => 20901273 [2] => 20901274 [3] => 20901275 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) [~VALUE] => Array ( [0] => 12260 [1] => 12257 [2] => 12256 [3] => 12259 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) ) [RECOMMENT_COURSE] => Array ( [ID] => 388 [IBLOCK_ID] => 26 [NAME] => Рекомендуемые курсы [ACTIVE] => Y [SORT] => 1700 [CODE] => RECOMMENT_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 295 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Рекомендуемые курсы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TARIF_PLAN] => Array ( [ID] => 389 [IBLOCK_ID] => 26 [NAME] => Тарифные планы [ACTIVE] => Y [SORT] => 1750 [CODE] => TARIF_PLAN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 296 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тарифные планы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PODZAGOLOVOK_NAME] => Array ( [ID] => 390 [IBLOCK_ID] => 26 [NAME] => Подзаголовок для названия [ACTIVE] => Y [SORT] => 1800 [CODE] => PODZAGOLOVOK_NAME [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 309 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Подзаголовок для названия [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_PROGRAMM] => Array ( [ID] => 391 [IBLOCK_ID] => 26 [NAME] => Заголовок - Образовательная программа [ACTIVE] => Y [SORT] => 1850 [CODE] => TITLE_PROGRAMM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 310 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Образовательная программа [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_KURSE] => Array ( [ID] => 392 [IBLOCK_ID] => 26 [NAME] => Сертификаты (блок) [ACTIVE] => Y [SORT] => 1900 [CODE] => SERTIF_KURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 311 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сертификаты (блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PACKET_PRED] => Array ( [ID] => 393 [IBLOCK_ID] => 26 [NAME] => Пакетные предложения [ACTIVE] => Y [SORT] => 1950 [CODE] => PACKET_PRED [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 312 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 63 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Пакетные предложения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SALE] => Array ( [ID] => 394 [IBLOCK_ID] => 26 [NAME] => Акция [ACTIVE] => Y [SORT] => 2000 [CODE] => SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 366 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Акция [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [TITLE_ANNOTATION] => Array ( [ID] => 395 [IBLOCK_ID] => 26 [NAME] => Заголовок - Аннотация [ACTIVE] => Y [SORT] => 2050 [CODE] => TITLE_ANNOTATION [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 370 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Аннотация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_COURSE] => Array ( [ID] => 396 [IBLOCK_ID] => 26 [NAME] => Заголовок - Цель курса [ACTIVE] => Y [SORT] => 2100 [CODE] => TITLE_CEL_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 371 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Цель курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_AUDITOR] => Array ( [ID] => 397 [IBLOCK_ID] => 26 [NAME] => Заголовок - Целевая аудитория [ACTIVE] => Y [SORT] => 2150 [CODE] => TITLE_CEL_AUDITOR [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 372 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Целевая аудитория [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SODERSHANIE] => Array ( [ID] => 398 [IBLOCK_ID] => 26 [NAME] => Заголовок - Содержание [ACTIVE] => Y [SORT] => 2200 [CODE] => TITLE_SODERSHANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 373 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Содержание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SERTIF] => Array ( [ID] => 399 [IBLOCK_ID] => 26 [NAME] => Заголовок - Сертификация [ACTIVE] => Y [SORT] => 2250 [CODE] => TITLE_SERTIF [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 374 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Сертификация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_DOCUMENT] => Array ( [ID] => 400 [IBLOCK_ID] => 26 [NAME] => Заголовок - Получаемый документ [ACTIVE] => Y [SORT] => 2300 [CODE] => TITLE_DOCUMENT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 375 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Получаемый документ [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [CONNECT_BUY] => Array ( [ID] => 401 [IBLOCK_ID] => 26 [NAME] => Курс можно купить [ACTIVE] => Y [SORT] => 2350 [CODE] => CONNECT_BUY [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 377 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс можно купить [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [OFFERTA] => Array ( [ID] => 402 [IBLOCK_ID] => 26 [NAME] => Файл оферты [ACTIVE] => Y [SORT] => 2400 [CODE] => OFFERTA [DEFAULT_VALUE] => [PROPERTY_TYPE] => F [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 399 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => Размещать оферту только в том случае, если она отличается от стандартной [~NAME] => Файл оферты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [POPULAR_COURSE_SORT] => Array ( [ID] => 752 [IBLOCK_ID] => 26 [NAME] => Сортировка (Популярные курсы) [ACTIVE] => Y [SORT] => 2450 [CODE] => POPULAR_COURSE_SORT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сортировка (Популярные курсы) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [RASPISANIE_TITLE] => Array ( [ID] => 761 [IBLOCK_ID] => 26 [NAME] => Расписание (Заголовок) [ACTIVE] => Y [SORT] => 2500 [CODE] => RASPISANIE_TITLE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание (Заголовок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Содержание [PROPERTY_VALUE_ID] => 21375150 [DESCRIPTION] => [~VALUE] => Содержание [~DESCRIPTION] => ) [code] => Array ( [ID] => 180 [IBLOCK_ID] => 26 [NAME] => Код курса (служебное) [ACTIVE] => Y [SORT] => 2550 [CODE] => code [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 180 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Код курса (служебное) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Excel_F [PROPERTY_VALUE_ID] => 21337823 [DESCRIPTION] => [~VALUE] => Excel_F [~DESCRIPTION] => ) [MARKET_CATEGOR] => Array ( [ID] => 762 [IBLOCK_ID] => 26 [NAME] => Категория Яндекс.Маркет [ACTIVE] => Y [SORT] => 3000 [CODE] => MARKET_CATEGOR [DEFAULT_VALUE] => 3205 [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => ym_service_category [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Категория Яндекс.Маркет [~DEFAULT_VALUE] => 3205 [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 3205 [PROPERTY_VALUE_ID] => 21389984 [DESCRIPTION] => [~VALUE] => 3205 [~DESCRIPTION] => ) [POST_TEACHERS] => ) [DISPLAY_PROPERTIES] => Array ( ) [IPROPERTY_VALUES] => Array ( [ELEMENT_META_DESCRIPTION] => В курсе будет рассмотрен как функционал, общий для версий Microsoft Excel 2019/2016, так и новые возможности MS Excel 2016, такие как быстрый анализ таблиц и настройка диаграмм.<b>По окончании курса Вы будете уметь:</b><b><br> </b> <ul> <li> Понимать структуру книги Excel</li> <li> Правильно вводить данные, использовать заполнение ячеек списками и данных прогрессий</li> <li> Осуществлять вычисления по формулам с использованием данных, находящихся как на одном, так и на разных листах</li> <li> Получать результаты расчета данных по функциям</li> <li> Оформлять таблицы в соответствии с любыми требованиями</li> <li> Строить диаграммы для наглядного представления табличных данных</li> <li> Осуществлять сортировку и фильтровку данных</li> <li> Подготовить и вывести на печать как таблицу, так и диаграмму</li> </ul> [ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. Базовый уровень ) )
- Использовать автоматическую запись макроса в Excel и исправлять недостатки автоматически генерируемого программного кода
- Создавать проекты в редакторе VBA, редактировать, отлаживать и выполнять программный код
- Программировать работу с переменными, условные переходы и циклы, диалоги для ввода значений и вывода сообщений
- Программировать доступ и управление объектами Excel (такими как рабочая книга, рабочие листы и диапазоны ячеек)
- Создавать и применять пользовательские функции
По окончании курса Вы будете уметь:
- Использовать автоматическую запись макроса в Excel и исправлять недостатки автоматически генерируемого программного кода
- Создавать проекты в редакторе VBA, редактировать, отлаживать и выполнять программный код
- Программировать работу с переменными, условные переходы и циклы, диалоги для ввода значений и вывода сообщений
- Программировать доступ и управление объектами Excel (такими как рабочая книга, рабочие листы и диапазоны ячеек)
- Создавать и применять пользовательские функции
- Загружать данные в модель данных PowerPivot из внешних источников
- Создавать связи между таблицами в модели данных
- Импортировать данные в модель PowerPivot с использованием PowerQuery
- Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery
- Выполнять анализ и моделирование данных с помощью PowerPivot
- Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы
- Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм
- Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета
- Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map
Полученные данные можно будет представить в комбинированных отчетах сводных таблиц и сводных диаграмм, причем как зависимых, так и независимых друг от друга. Вы научитесь строить интуитивно понятные динамические отчеты PowerView для изучения, визуализации и представления данных как в табличном, так и графическом виде.
PowerPivot, PowerQuery, PowerView и PowerMap – это мощные современные инструменты анализа данных в Microsoft Excel!
По окончании курса Вы будете уметь:
- Загружать данные в модель данных PowerPivot из внешних источников
- Создавать связи между таблицами в модели данных
- Импортировать данные в модель PowerPivot с использованием PowerQuery
- Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery
- Выполнять анализ и моделирование данных с помощью PowerPivot
- Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы
- Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм
- Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета
- Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map
Формирование знаний и навыков, связанных с бизнес - аналитикой с использованием PowerPivot и PowerView.
[TYPE] => HTML ) [~DESCRIPTION] => ) [AUDIT_CATALOG] => Array ( [ID] => 75 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория [ACTIVE] => Y [SORT] => 750 [CODE] => AUDIT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 75 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Целевая аудитория [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TRAIN_CATALOG] => Array ( [ID] => 76 [IBLOCK_ID] => 26 [NAME] => Необходимая подготовка [ACTIVE] => Y [SORT] => 800 [CODE] => TRAIN_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 76 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Необходимая подготовка [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => Желательно прохождение курса <b>Microsoft Excel 2019/2016. Продвинутый уровень</b> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896348 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => Желательно прохождение курса Microsoft Excel 2019/2016. Продвинутый уровень [TYPE] => HTML ) [~DESCRIPTION] => ) [CONTENT_CATALOG] => Array ( [ID] => 77 [IBLOCK_ID] => 26 [NAME] => Содержание [ACTIVE] => Y [SORT] => 850 [CODE] => CONTENT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 77 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Содержание [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_CATALOG] => Array ( [ID] => 78 [IBLOCK_ID] => 26 [NAME] => Сертификация [ACTIVE] => Y [SORT] => 900 [CODE] => SERTIF_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 78 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Сертификация [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DOC_CATALOG] => Array ( [ID] => 79 [IBLOCK_ID] => 26 [NAME] => Получаемый документ [ACTIVE] => Y [SORT] => 950 [CODE] => DOC_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 79 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Получаемый документ [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <img width="612" alt="Сертификат.jpg" src="/upload/medialibrary/b37/b370784d3f620d37311f6ecb970a4aec.jpg" height="420" title="Сертификат.jpg"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20901305 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [~DESCRIPTION] => ) [LENGTH_CATALOG] => Array ( [ID] => 80 [IBLOCK_ID] => 26 [NAME] => Продолжительность обучения [ACTIVE] => Y [SORT] => 1000 [CODE] => LENGTH_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 80 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Продолжительность обучения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 2 дня /16 часов [PROPERTY_VALUE_ID] => 20893825 [DESCRIPTION] => [~VALUE] => 2 дня /16 часов [~DESCRIPTION] => ) [prepodavatel] => Array ( [ID] => 82 [IBLOCK_ID] => 26 [NAME] => Преподаватели [ACTIVE] => Y [SORT] => 1050 [CODE] => prepodavatel [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 82 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Преподаватели [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 2852 [1] => 10420 [2] => 163 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901310 [1] => 20901311 [2] => 20901312 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => ) [~VALUE] => Array ( [0] => 2852 [1] => 10420 [2] => 163 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => ) ) [FORUM_TOPIC_ID] => Array ( [ID] => 175 [IBLOCK_ID] => 26 [NAME] => Тема форума для комментариев [ACTIVE] => Y [SORT] => 1150 [CODE] => FORUM_TOPIC_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 175 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тема форума для комментариев [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [FORUM_MESSAGE_CNT] => Array ( [ID] => 176 [IBLOCK_ID] => 26 [NAME] => Количество комментариев к элементу [ACTIVE] => Y [SORT] => 1200 [CODE] => FORUM_MESSAGE_CNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 176 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество комментариев к элементу [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [OPTIONS_CATALOG] => Array ( [ID] => 229 [IBLOCK_ID] => 26 [NAME] => Доп. опции [ACTIVE] => Y [SORT] => 1300 [CODE] => OPTIONS_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 229 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 60 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => EList [USER_TYPE_SETTINGS] => Array ( [size] => 1 [width] => 0 [group] => N [multiple] => N ) [HINT] => [~NAME] => Доп. опции [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [MOODLE_ID] => Array ( [ID] => 244 [IBLOCK_ID] => 26 [NAME] => ID курса в СДО [ACTIVE] => Y [SORT] => 1350 [CODE] => MOODLE_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => ID курса в СДО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [COUNT_ORDER] => Array ( [ID] => 248 [IBLOCK_ID] => 26 [NAME] => Количество заказов [ACTIVE] => Y [SORT] => 1400 [CODE] => COUNT_ORDER [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество заказов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [IN_ASO] => Array ( [ID] => 251 [IBLOCK_ID] => 26 [NAME] => Курс в АСО [ACTIVE] => Y [SORT] => 1450 [CODE] => IN_ASO [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс в АСО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [VARIANTY_VIEZD] => Array ( [ID] => 384 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория (Новый блок) [ACTIVE] => Y [SORT] => 1500 [CODE] => VARIANTY_VIEZD [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 288 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Целевая аудитория (Новый блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 26254 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364366 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 26254 ) [~DESCRIPTION] => Array ( [0] => ) ) [RAZPISANIE] => Array ( [ID] => 385 [IBLOCK_ID] => 26 [NAME] => Расписание [ACTIVE] => Y [SORT] => 1550 [CODE] => RAZPISANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 289 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 64 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 26255 [1] => 26256 [2] => 26257 [3] => 26258 [4] => 26259 [5] => 26260 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364367 [1] => 21364368 [2] => 21364369 [3] => 21364370 [4] => 21364371 [5] => 21364372 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) [~VALUE] => Array ( [0] => 26255 [1] => 26256 [2] => 26257 [3] => 26258 [4] => 26259 [5] => 26260 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) ) [VIDEO] => Array ( [ID] => 386 [IBLOCK_ID] => 26 [NAME] => Видео [ACTIVE] => Y [SORT] => 1600 [CODE] => VIDEO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 293 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Видео [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [EKSAMEN] => Array ( [ID] => 387 [IBLOCK_ID] => 26 [NAME] => Экзамены [ACTIVE] => Y [SORT] => 1650 [CODE] => EKSAMEN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 294 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Экзамены [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [prods] => Array ( [ID] => 83 [IBLOCK_ID] => 26 [NAME] => Похожие (связанные) продукты [ACTIVE] => Y [SORT] => 1670 [CODE] => prods [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 83 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Похожие (связанные) продукты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 12260 [1] => 12257 [2] => 12256 [3] => 12258 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901313 [1] => 20901314 [2] => 20901315 [3] => 20901316 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) [~VALUE] => Array ( [0] => 12260 [1] => 12257 [2] => 12256 [3] => 12258 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => ) ) [RECOMMENT_COURSE] => Array ( [ID] => 388 [IBLOCK_ID] => 26 [NAME] => Рекомендуемые курсы [ACTIVE] => Y [SORT] => 1700 [CODE] => RECOMMENT_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 295 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Рекомендуемые курсы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TARIF_PLAN] => Array ( [ID] => 389 [IBLOCK_ID] => 26 [NAME] => Тарифные планы [ACTIVE] => Y [SORT] => 1750 [CODE] => TARIF_PLAN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 296 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тарифные планы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PODZAGOLOVOK_NAME] => Array ( [ID] => 390 [IBLOCK_ID] => 26 [NAME] => Подзаголовок для названия [ACTIVE] => Y [SORT] => 1800 [CODE] => PODZAGOLOVOK_NAME [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 309 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Подзаголовок для названия [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_PROGRAMM] => Array ( [ID] => 391 [IBLOCK_ID] => 26 [NAME] => Заголовок - Образовательная программа [ACTIVE] => Y [SORT] => 1850 [CODE] => TITLE_PROGRAMM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 310 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Образовательная программа [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_KURSE] => Array ( [ID] => 392 [IBLOCK_ID] => 26 [NAME] => Сертификаты (блок) [ACTIVE] => Y [SORT] => 1900 [CODE] => SERTIF_KURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 311 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сертификаты (блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PACKET_PRED] => Array ( [ID] => 393 [IBLOCK_ID] => 26 [NAME] => Пакетные предложения [ACTIVE] => Y [SORT] => 1950 [CODE] => PACKET_PRED [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 312 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 63 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Пакетные предложения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SALE] => Array ( [ID] => 394 [IBLOCK_ID] => 26 [NAME] => Акция [ACTIVE] => Y [SORT] => 2000 [CODE] => SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 366 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Акция [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [TITLE_ANNOTATION] => Array ( [ID] => 395 [IBLOCK_ID] => 26 [NAME] => Заголовок - Аннотация [ACTIVE] => Y [SORT] => 2050 [CODE] => TITLE_ANNOTATION [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 370 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Аннотация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_COURSE] => Array ( [ID] => 396 [IBLOCK_ID] => 26 [NAME] => Заголовок - Цель курса [ACTIVE] => Y [SORT] => 2100 [CODE] => TITLE_CEL_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 371 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Цель курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_AUDITOR] => Array ( [ID] => 397 [IBLOCK_ID] => 26 [NAME] => Заголовок - Целевая аудитория [ACTIVE] => Y [SORT] => 2150 [CODE] => TITLE_CEL_AUDITOR [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 372 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Целевая аудитория [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SODERSHANIE] => Array ( [ID] => 398 [IBLOCK_ID] => 26 [NAME] => Заголовок - Содержание [ACTIVE] => Y [SORT] => 2200 [CODE] => TITLE_SODERSHANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 373 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Содержание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SERTIF] => Array ( [ID] => 399 [IBLOCK_ID] => 26 [NAME] => Заголовок - Сертификация [ACTIVE] => Y [SORT] => 2250 [CODE] => TITLE_SERTIF [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 374 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Сертификация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_DOCUMENT] => Array ( [ID] => 400 [IBLOCK_ID] => 26 [NAME] => Заголовок - Получаемый документ [ACTIVE] => Y [SORT] => 2300 [CODE] => TITLE_DOCUMENT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 375 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Получаемый документ [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [CONNECT_BUY] => Array ( [ID] => 401 [IBLOCK_ID] => 26 [NAME] => Курс можно купить [ACTIVE] => Y [SORT] => 2350 [CODE] => CONNECT_BUY [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 377 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс можно купить [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [OFFERTA] => Array ( [ID] => 402 [IBLOCK_ID] => 26 [NAME] => Файл оферты [ACTIVE] => Y [SORT] => 2400 [CODE] => OFFERTA [DEFAULT_VALUE] => [PROPERTY_TYPE] => F [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 399 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => Размещать оферту только в том случае, если она отличается от стандартной [~NAME] => Файл оферты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [POPULAR_COURSE_SORT] => Array ( [ID] => 752 [IBLOCK_ID] => 26 [NAME] => Сортировка (Популярные курсы) [ACTIVE] => Y [SORT] => 2450 [CODE] => POPULAR_COURSE_SORT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сортировка (Популярные курсы) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [RASPISANIE_TITLE] => Array ( [ID] => 761 [IBLOCK_ID] => 26 [NAME] => Расписание (Заголовок) [ACTIVE] => Y [SORT] => 2500 [CODE] => RASPISANIE_TITLE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание (Заголовок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Содержание [PROPERTY_VALUE_ID] => 21375247 [DESCRIPTION] => [~VALUE] => Содержание [~DESCRIPTION] => ) [code] => Array ( [ID] => 180 [IBLOCK_ID] => 26 [NAME] => Код курса (служебное) [ACTIVE] => Y [SORT] => 2550 [CODE] => code [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 180 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Код курса (служебное) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Excel_PP [PROPERTY_VALUE_ID] => 21337839 [DESCRIPTION] => [~VALUE] => Excel_PP [~DESCRIPTION] => ) [MARKET_CATEGOR] => Array ( [ID] => 762 [IBLOCK_ID] => 26 [NAME] => Категория Яндекс.Маркет [ACTIVE] => Y [SORT] => 3000 [CODE] => MARKET_CATEGOR [DEFAULT_VALUE] => 3205 [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => ym_service_category [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Категория Яндекс.Маркет [~DEFAULT_VALUE] => 3205 [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 3205 [PROPERTY_VALUE_ID] => 21389981 [DESCRIPTION] => [~VALUE] => 3205 [~DESCRIPTION] => ) [POST_TEACHERS] => ) [DISPLAY_PROPERTIES] => Array ( ) [IPROPERTY_VALUES] => Array ( [ELEMENT_META_DESCRIPTION] => Access, SQL-сервер, OLAP-куб, файлы Excel и т.д., загружая их в модель PowerPivot напрямую или предварительно обработав в PowerQuery. При необходимости создавать связи между всеми этими источниками, выполнять различные расчеты, как с использованием простых вычислений, так и с применением функций. Вы больше не будете зависеть от разработчиков, т.к. все отчеты Вы сможете строить сами.<br> <br> Полученные данные можно будет представить в комбинированных отчетах сводных таблиц и сводных диаграмм, причем как зависимых, так и независимых друг от друга. Вы научитесь строить интуитивно понятные динамические отчеты PowerView для изучения, визуализации и представления данных как в табличном, так и графическом виде. <br> PowerPivot, PowerQuery, PowerView и PowerMap – это мощные современные инструменты анализа данных в Microsoft Excel!<br> <br> <b>По окончании курса Вы будете уметь:</b><br> <br> <ul> <li> Загружать данные в модель данных PowerPivot из внешних источников</li> <li> Создавать связи между таблицами в модели данных</li> <li> Импортировать данные в модель PowerPivot с использованием PowerQuery</li> <li> Редактировать, создавать вычисления, объединять и добавлять запросы PowerQuery</li> <li> Выполнять анализ и моделирование данных с помощью PowerPivot</li> <li> Строить DAX-формулы для получения результатов обработки как по простым формулам, так и с применением функций различных категорий, создавая как вычисляемые поля, так и вычисляемые столбцы</li> <li> Выполнять построение комбинированных отчетов как в виде сводных таблиц, так и сводных диаграмм</li> <li> Создавать интуитивно понятные специализированные динамические отчеты Power View для представления данных в виде таблицы, матрицы, наборов различных диаграмм и управлять данными отчета</li> <li> Строить наглядные отчеты для анализа данных с привязкой к географическому расположению как с PowerView, так и с Power Map</li> </ul> [ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. Бизнес - аналитика с использованием PowerPivot и PowerView ) )
- программировать сложные процедуры с вложенными циклами, использующие массивы переменных
- автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок
- автоматизировать создания cводных таблиц
- создавать пользовательские формы для организации диалоговых окон для работы пользователей
- создавать надстройки Microsoft Excel 2019/2016 с помощью VBA
В курсе рассматриваются вопросы автоматизации обработки множества рабочих файлов, организации доступа к базам данных, создания диалоговых окон для конечного пользователя и оформления проекта VBA в виде надстройки Excel.
По окончании курса Вы будете уметь:
- программировать сложные процедуры с вложенными циклами, использующие массивы переменных
- автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок
- автоматизировать создания cводных таблиц
- создавать пользовательские формы для организации диалоговых окон для работы пользователей
- создавать надстройки Microsoft Excel 2019/2016 с помощью VBA
Совершенствование знаний и навыков, необходимых для углубленного изучения программирования в среде Microsoft Excel 2019/2016.
[TYPE] => HTML ) [~DESCRIPTION] => ) [AUDIT_CATALOG] => Array ( [ID] => 75 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория [ACTIVE] => Y [SORT] => 750 [CODE] => AUDIT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 75 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Целевая аудитория [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TRAIN_CATALOG] => Array ( [ID] => 76 [IBLOCK_ID] => 26 [NAME] => Необходимая подготовка [ACTIVE] => Y [SORT] => 800 [CODE] => TRAIN_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 76 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Необходимая подготовка [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => Желательно прохождение курса <b><a href="http://www.academy.it.ru/courses/Excel_VBA">Microsoft Excel 2019/2016. Макросы на VBA</a></b> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896326 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => Желательно прохождение курса Microsoft Excel 2019/2016. Макросы на VBA [TYPE] => HTML ) [~DESCRIPTION] => ) [CONTENT_CATALOG] => Array ( [ID] => 77 [IBLOCK_ID] => 26 [NAME] => Содержание [ACTIVE] => Y [SORT] => 850 [CODE] => CONTENT_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 77 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Содержание [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_CATALOG] => Array ( [ID] => 78 [IBLOCK_ID] => 26 [NAME] => Сертификация [ACTIVE] => Y [SORT] => 900 [CODE] => SERTIF_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 78 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Сертификация [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [DOC_CATALOG] => Array ( [ID] => 79 [IBLOCK_ID] => 26 [NAME] => Получаемый документ [ACTIVE] => Y [SORT] => 950 [CODE] => DOC_CATALOG [DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 79 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => HTML [USER_TYPE_SETTINGS] => Array ( [height] => 200 ) [HINT] => [~NAME] => Получаемый документ [~DEFAULT_VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [TEXT] => <img width="437" alt="Сертификат.jpg" src="/upload/medialibrary/b37/b370784d3f620d37311f6ecb970a4aec.jpg" height="300" title="Сертификат.jpg"><img width="437" alt="Certifiate_Microsoft.jpg" src="/upload/medialibrary/f15/f1547ee55c54b5992981f7a5c4e4db14.jpg" height="316" title="Certifiate_Microsoft.jpg"> [TYPE] => HTML ) [PROPERTY_VALUE_ID] => 20896328 [DESCRIPTION] => [~VALUE] => Array ( [TEXT] => [TYPE] => HTML ) [~DESCRIPTION] => ) [LENGTH_CATALOG] => Array ( [ID] => 80 [IBLOCK_ID] => 26 [NAME] => Продолжительность обучения [ACTIVE] => Y [SORT] => 1000 [CODE] => LENGTH_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 80 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Продолжительность обучения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 2 дня /16 часов [PROPERTY_VALUE_ID] => 20893841 [DESCRIPTION] => [~VALUE] => 2 дня /16 часов [~DESCRIPTION] => ) [prepodavatel] => Array ( [ID] => 82 [IBLOCK_ID] => 26 [NAME] => Преподаватели [ACTIVE] => Y [SORT] => 1050 [CODE] => prepodavatel [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 82 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 25 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Преподаватели [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 163 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901361 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 163 ) [~DESCRIPTION] => Array ( [0] => ) ) [FORUM_TOPIC_ID] => Array ( [ID] => 175 [IBLOCK_ID] => 26 [NAME] => Тема форума для комментариев [ACTIVE] => Y [SORT] => 1150 [CODE] => FORUM_TOPIC_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 175 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тема форума для комментариев [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [FORUM_MESSAGE_CNT] => Array ( [ID] => 176 [IBLOCK_ID] => 26 [NAME] => Количество комментариев к элементу [ACTIVE] => Y [SORT] => 1200 [CODE] => FORUM_MESSAGE_CNT [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 176 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество комментариев к элементу [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [OPTIONS_CATALOG] => Array ( [ID] => 229 [IBLOCK_ID] => 26 [NAME] => Доп. опции [ACTIVE] => Y [SORT] => 1300 [CODE] => OPTIONS_CATALOG [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 229 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 60 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => EList [USER_TYPE_SETTINGS] => Array ( [size] => 1 [width] => 0 [group] => N [multiple] => N ) [HINT] => [~NAME] => Доп. опции [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [MOODLE_ID] => Array ( [ID] => 244 [IBLOCK_ID] => 26 [NAME] => ID курса в СДО [ACTIVE] => Y [SORT] => 1350 [CODE] => MOODLE_ID [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => ID курса в СДО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [COUNT_ORDER] => Array ( [ID] => 248 [IBLOCK_ID] => 26 [NAME] => Количество заказов [ACTIVE] => Y [SORT] => 1400 [CODE] => COUNT_ORDER [DEFAULT_VALUE] => [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Количество заказов [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [IN_ASO] => Array ( [ID] => 251 [IBLOCK_ID] => 26 [NAME] => Курс в АСО [ACTIVE] => Y [SORT] => 1450 [CODE] => IN_ASO [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс в АСО [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [VARIANTY_VIEZD] => Array ( [ID] => 384 [IBLOCK_ID] => 26 [NAME] => Целевая аудитория (Новый блок) [ACTIVE] => Y [SORT] => 1500 [CODE] => VARIANTY_VIEZD [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 288 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Целевая аудитория (Новый блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 26269 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364443 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 26269 ) [~DESCRIPTION] => Array ( [0] => ) ) [RAZPISANIE] => Array ( [ID] => 385 [IBLOCK_ID] => 26 [NAME] => Расписание [ACTIVE] => Y [SORT] => 1550 [CODE] => RAZPISANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 289 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 64 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 26270 [1] => 26271 [2] => 26272 [3] => 26273 [4] => 26274 [5] => 26275 ) [PROPERTY_VALUE_ID] => Array ( [0] => 21364444 [1] => 21364445 [2] => 21364446 [3] => 21364447 [4] => 21364448 [5] => 21364449 ) [DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) [~VALUE] => Array ( [0] => 26270 [1] => 26271 [2] => 26272 [3] => 26273 [4] => 26274 [5] => 26275 ) [~DESCRIPTION] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => ) ) [VIDEO] => Array ( [ID] => 386 [IBLOCK_ID] => 26 [NAME] => Видео [ACTIVE] => Y [SORT] => 1600 [CODE] => VIDEO [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 293 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Видео [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [EKSAMEN] => Array ( [ID] => 387 [IBLOCK_ID] => 26 [NAME] => Экзамены [ACTIVE] => Y [SORT] => 1650 [CODE] => EKSAMEN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 294 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Экзамены [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [prods] => Array ( [ID] => 83 [IBLOCK_ID] => 26 [NAME] => Похожие (связанные) продукты [ACTIVE] => Y [SORT] => 1670 [CODE] => prods [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 83 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Похожие (связанные) продукты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Array ( [0] => 12259 ) [PROPERTY_VALUE_ID] => Array ( [0] => 20901362 ) [DESCRIPTION] => Array ( [0] => ) [~VALUE] => Array ( [0] => 12259 ) [~DESCRIPTION] => Array ( [0] => ) ) [RECOMMENT_COURSE] => Array ( [ID] => 388 [IBLOCK_ID] => 26 [NAME] => Рекомендуемые курсы [ACTIVE] => Y [SORT] => 1700 [CODE] => RECOMMENT_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 295 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 26 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => Выбранные курсы выводятся в карточке курса блок "Рекомендуемые курсы" [~NAME] => Рекомендуемые курсы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TARIF_PLAN] => Array ( [ID] => 389 [IBLOCK_ID] => 26 [NAME] => Тарифные планы [ACTIVE] => Y [SORT] => 1750 [CODE] => TARIF_PLAN [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 296 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Тарифные планы [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PODZAGOLOVOK_NAME] => Array ( [ID] => 390 [IBLOCK_ID] => 26 [NAME] => Подзаголовок для названия [ACTIVE] => Y [SORT] => 1800 [CODE] => PODZAGOLOVOK_NAME [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 309 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Подзаголовок для названия [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_PROGRAMM] => Array ( [ID] => 391 [IBLOCK_ID] => 26 [NAME] => Заголовок - Образовательная программа [ACTIVE] => Y [SORT] => 1850 [CODE] => TITLE_PROGRAMM [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 310 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Образовательная программа [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SERTIF_KURSE] => Array ( [ID] => 392 [IBLOCK_ID] => 26 [NAME] => Сертификаты (блок) [ACTIVE] => Y [SORT] => 1900 [CODE] => SERTIF_KURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 311 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сертификаты (блок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [PACKET_PRED] => Array ( [ID] => 393 [IBLOCK_ID] => 26 [NAME] => Пакетные предложения [ACTIVE] => Y [SORT] => 1950 [CODE] => PACKET_PRED [DEFAULT_VALUE] => [PROPERTY_TYPE] => E [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => Y [XML_ID] => 312 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 63 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Пакетные предложения [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [SALE] => Array ( [ID] => 394 [IBLOCK_ID] => 26 [NAME] => Акция [ACTIVE] => Y [SORT] => 2000 [CODE] => SALE [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 366 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Акция [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [TITLE_ANNOTATION] => Array ( [ID] => 395 [IBLOCK_ID] => 26 [NAME] => Заголовок - Аннотация [ACTIVE] => Y [SORT] => 2050 [CODE] => TITLE_ANNOTATION [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 370 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Аннотация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_COURSE] => Array ( [ID] => 396 [IBLOCK_ID] => 26 [NAME] => Заголовок - Цель курса [ACTIVE] => Y [SORT] => 2100 [CODE] => TITLE_CEL_COURSE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 371 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Цель курса [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_CEL_AUDITOR] => Array ( [ID] => 397 [IBLOCK_ID] => 26 [NAME] => Заголовок - Целевая аудитория [ACTIVE] => Y [SORT] => 2150 [CODE] => TITLE_CEL_AUDITOR [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 372 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Целевая аудитория [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SODERSHANIE] => Array ( [ID] => 398 [IBLOCK_ID] => 26 [NAME] => Заголовок - Содержание [ACTIVE] => Y [SORT] => 2200 [CODE] => TITLE_SODERSHANIE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 373 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Содержание [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_SERTIF] => Array ( [ID] => 399 [IBLOCK_ID] => 26 [NAME] => Заголовок - Сертификация [ACTIVE] => Y [SORT] => 2250 [CODE] => TITLE_SERTIF [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 374 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Сертификация [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [TITLE_DOCUMENT] => Array ( [ID] => 400 [IBLOCK_ID] => 26 [NAME] => Заголовок - Получаемый документ [ACTIVE] => Y [SORT] => 2300 [CODE] => TITLE_DOCUMENT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 375 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Заголовок - Получаемый документ [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [CONNECT_BUY] => Array ( [ID] => 401 [IBLOCK_ID] => 26 [NAME] => Курс можно купить [ACTIVE] => Y [SORT] => 2350 [CODE] => CONNECT_BUY [DEFAULT_VALUE] => [PROPERTY_TYPE] => L [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => C [MULTIPLE] => N [XML_ID] => 377 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Курс можно купить [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => [VALUE_ENUM_ID] => ) [OFFERTA] => Array ( [ID] => 402 [IBLOCK_ID] => 26 [NAME] => Файл оферты [ACTIVE] => Y [SORT] => 2400 [CODE] => OFFERTA [DEFAULT_VALUE] => [PROPERTY_TYPE] => F [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 399 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => [HINT] => Размещать оферту только в том случае, если она отличается от стандартной [~NAME] => Файл оферты [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [POPULAR_COURSE_SORT] => Array ( [ID] => 752 [IBLOCK_ID] => 26 [NAME] => Сортировка (Популярные курсы) [ACTIVE] => Y [SORT] => 2450 [CODE] => POPULAR_COURSE_SORT [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Сортировка (Популярные курсы) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [RASPISANIE_TITLE] => Array ( [ID] => 761 [IBLOCK_ID] => 26 [NAME] => Расписание (Заголовок) [ACTIVE] => Y [SORT] => 2500 [CODE] => RASPISANIE_TITLE [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => N [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Расписание (Заголовок) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => [PROPERTY_VALUE_ID] => [DESCRIPTION] => [~DESCRIPTION] => [~VALUE] => ) [code] => Array ( [ID] => 180 [IBLOCK_ID] => 26 [NAME] => Код курса (служебное) [ACTIVE] => Y [SORT] => 2550 [CODE] => code [DEFAULT_VALUE] => [PROPERTY_TYPE] => S [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => 180 [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => N [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Код курса (служебное) [~DEFAULT_VALUE] => [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => Excel_VBAA [PROPERTY_VALUE_ID] => 21337846 [DESCRIPTION] => [~VALUE] => Excel_VBAA [~DESCRIPTION] => ) [MARKET_CATEGOR] => Array ( [ID] => 762 [IBLOCK_ID] => 26 [NAME] => Категория Яндекс.Маркет [ACTIVE] => Y [SORT] => 3000 [CODE] => MARKET_CATEGOR [DEFAULT_VALUE] => 3205 [PROPERTY_TYPE] => N [ROW_COUNT] => 1 [COL_COUNT] => 30 [LIST_TYPE] => L [MULTIPLE] => N [XML_ID] => [FILE_TYPE] => [MULTIPLE_CNT] => 5 [LINK_IBLOCK_ID] => 0 [WITH_DESCRIPTION] => N [SEARCHABLE] => Y [FILTRABLE] => Y [IS_REQUIRED] => N [VERSION] => 1 [USER_TYPE] => ym_service_category [USER_TYPE_SETTINGS] => Array ( ) [HINT] => [~NAME] => Категория Яндекс.Маркет [~DEFAULT_VALUE] => 3205 [VALUE_ENUM] => [VALUE_XML_ID] => [VALUE_SORT] => [VALUE] => 3205 [PROPERTY_VALUE_ID] => 21389979 [DESCRIPTION] => [~VALUE] => 3205 [~DESCRIPTION] => ) [POST_TEACHERS] => ) [DISPLAY_PROPERTIES] => Array ( ) [IPROPERTY_VALUES] => Array ( [ELEMENT_META_DESCRIPTION] => Наибольшее количество прикладных задач, которые невозможно реализовать без макросов, возникает при работе с электронными таблицами Excel.<br> <br> В курсе рассматриваются вопросы автоматизации обработки множества рабочих файлов, организации доступа к базам данных, создания диалоговых окон для конечного пользователя и оформления проекта VBA в виде надстройки Excel.<br> <br> <b> По окончании курса Вы будете уметь:<br> </b><br> <ul> <li> программировать сложные процедуры с вложенными циклами, использующие массивы переменных</li> <li> автоматизировать работу с файловой системой, использовать диалоги для выбора файлов и папок</li> <li> автоматизировать создания cводных таблиц</li> <li> создавать пользовательские формы для организации диалоговых окон для работы пользователей</li> <li> создавать надстройки Microsoft Excel 2019/2016 с помощью VBA</li> </ul> [ELEMENT_META_TITLE] => Microsoft Excel 2019/2016. VBA. Углубленное программирование ) )
1 отзывов
Руководство Челябинского филиала АО «Первая Грузовая Компания» выражает благодарность за отлично проведенную работу по повышению квалификации наших руководителей и специалистов, прошедших обучение по программе “Применение информационно-коммуникационных технологий в управлении организацией, Пользователь MS Office 2010/2013”.
В обучении приняли участие сорок сотрудников производственного, коммерческого, вагонного и обеспечивающего блоков филиала.
Хотим поблагодарить и отметить высокую квалификацию и профессионализм педагога Андреевой Александры Романовны, благодаря которым обучение прошло результативно и успешно. Благодарим за качественное обучение и надеемся, что в ближайшее время сможем продолжить сотрудничество с Вами.
Выражаем свою признательность за Ваш плодотворный труд и желаем Институту информационных технологий “АйТи” дальнейшего процветания и профессиональных побед.
Чтобы оставить отзыв необходимо авторизоваться на сайте или зарегистрироваться.